package com.auxgroup.hr.front.dao.repository;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.auxgroup.hr.front.dao.domain.PsCEmpAbsentVwPrimary;
import com.auxgroup.hr.front.dao.domain.PsCEmpMatchVw;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCEmpMatchVwRepository extends
JpaRepository<PsCEmpMatchVw,PsCEmpAbsentVwPrimary>,JpaSpecificationExecutor<PsCEmpMatchVw> {
	
	
	@Query(value ="from PsCEmpMatchVw d where d.emplid=:emplid and d.emplRcd='0' and to_char(d.dateDay,'YYYY-MM')=:dateMonth order by d.dateDay ASC")
	public List<PsCEmpMatchVw> queryMatchsByDateMonth(@Param("emplid") String emplid, @Param("dateMonth") String dateMonth);
}